Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# TS_PITR_CHECK

This view, created by `catpitr.sql`, provides information on any dependencies or restrictions that might prevent tablespace point-in-time recovery from proceeding. This view applies only to the tablespace point-in-time recovery feature.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OBJ1_OWNER` | `VARCHAR2(30)` | `NOT NULL` | The owner of the object preventing tablespace point-in-time recovery. See the `REASON` column for details.
`OBJ1_NAME` | `VARCHAR2(30)` | `NOT NULL` | The name of the object preventing tablespace point-in-time recovery
`OBJ1_TYPE` | `VARCHAR2(15)` |  | The object type for the object preventing tablespace point-in-time recovery
`OBJ1_SUBNAME` | `VARCHAR2(30)` |  | Subordinate to `OBJ1_NAME`
`TS1_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the tablespace containing the object preventing tablespace point-in-time recovery
`OBJ2_NAME` | `VARCHAR2(30)` |  | The name of a second object which may be preventing tablespace point-in-time recovery. If NULL, object 1 is the only object preventing recovery.
`OBJ2_TYPE` | `VARCHAR2(15)` |  | The object type for the second object (will be NULL if `OBJ2_NAME` is NULL)
`OBJ2_OWNER` | `VARCHAR2(30)` |  | The owner of the second object (will be NULL if `OBJ2_NAME` is NULL)
`OBJ2_SUBNAME` | `VARCHAR2(30)` |  | Subordinate to `OBJ2_NAME`
`TS2_NAME` | `VARCHAR2(30)` |  | Name of the tablespace containing second object which may be preventing tablespace point-in-time recovery (-1 indicates not applicable)
`CONSTRAINT_NAME` | `VARCHAR2(30)` |  | Name of the constraint
`REASON` | `VARCHAR2(78)` |  | Reason why tablespace point-in-time recovery cannot proceed

See Also: Oracle Database Backup and Recovery Basics